package teach.aistar.mapper;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import teach.aistar.model.entity.Orders;
import teach.aistar.model.entity.WebOrder;

import java.util.Date;
import java.util.List;

public interface OrderMapper {
    @Select("select * from orders")
    List<Orders> selectOrderAll();

    int deleteById(int id);

    @Insert("insert into web_order values(null,#{orderNo},#{uName},#{orderStatus},#{secId},#{time},#{price})")
    int saveOrder(@Param("orderNo") String orderNo, @Param("uName") String uName, @Param("orderStatus") String orderStatus, @Param("secId") Long secId,@Param("time") Date time,@Param("price") Double price);
//
//    @Select("select * from web_order where uName= #{uName}")
//    List<WebOrder> findSekId(String uName);
}
